S3 Vectors

Samples Overview

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of S3 Vectors components in the folder depicted below.

  

  

  

Metadata Schemas

This general purpose template is at “Qarbine_admin/Cached schemas for prompted data service”. It displays information on all of the cached schemas. These schemas are saved as users interact with data tools such as the Data Source Designer, Query by Example, and Report by Example. If a particular collection is not shown in the output, simply open one of these tools and select it from the collection drop down to create it. Then rerun the template.

Running the template prompts for a data service and database (graph).

  

Below is a sample snippet from running the template.

  

All S3 Vector Buckets Report

This template is at “example/AWS/S3 Vectors/DBA/Describe all buckets”. It abortion of its output is shown below.

  

Clicking the highlighted image below opens the general AWS Web Console page for the S3 Vectors.

  

It uses the formula

=  formatAwsConsoleUrl('s3vectors', 'general', #vectorBucketArn)

Clicking the highlighted image below opens the AWS Web Console page for the S3 Vectors bucket.

  

It uses the formula

=  formatAwsConsoleUrl('s3vectors', 'bucket', #vectorBucketArn)

Clicking the highlighted image below copies the bucket’s ARN.

  

It uses the formula

= "next"

The timestamp values are in seconds so the creation time uses

newDate(#creationTime * 1000)

All S3 Vector Buckets and Indexes Report

This template is at“example/AWS/S3 Vectors/DBA/Describe all buckets and their indexes”. A portion of its output is shown below.

  

Each bucket’s indexes are included in this report. As with the previous template, there are convenient image buttons to open the AWS Web Console and also copy ARNs.